In some cases, no values will print when using a group selection formula, even though there are values that match the selection criteria. Typically, in these cases:
For each order, the report shows the customer that placed the order, the region in which that customer is located, the order ID number, and the amount of the order.
The program sorts the data by state and calculates a subtotal in the {orders.ORDER AMOUNT} field every time the state changes. See Subtotaling data.
Sum({orders.ORDER AMOUNT}, {customer.REGION})
% Sum({orders.ORDER AMOUNT})
{@Percent} < 5
When you click Save and Close, you will receive the following error message:
This formula can not be used because it must be evaluated later.
{@Percent} < 5
use the group selection formula:
Sum({orders.ORDER AMOUNT}, {customer.REGION})
% Sum({orders.ORDER AMOUNT}) < 5
Now when you print, only the regions that contributed less than 5% will print.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |